Aleno Token Report PoC¶

This POC is done on ERC20 contracts where we analyse the token holders. This same analysis can be done on any contract type to analyze the users and can be automated¶

Token general information¶

Token name :  Capsule Coin
Token symbol :  CAPS
Token ID 34288
Statistics computed 2022-10-21 15:43:39
 Price 0.009670733
total dex volume 1 B CAPS
total dex usd volume 60 M$
Capsule Coin is swapped in 3 pools on 2 different exchanges
address protocol_id swap_count usd_volume
0x456fb056a8d118300b624d3aee3864e685ae086c Uniswap v2 21832 58713060.000000
0x782db22763c7d565d3833a9238f24237ef44a233 SushiSwap 826 2618404.250000
0x3ee7dc29293935b474df93878592d01f82b76dc9 SushiSwap 5 264.746505

Price evolution¶

Accounts analysis¶

6957 have been exposed to Capsule Coin through decentralized exchanges on ethereum
4636 accounts have bought Capsule Coin on decentralized exchanges and have a non null balance
6399 are currently holding Capsule Coin

At the moment we can analyse 3 types of players:

  • All the addresses that interacted with the token through DEXES
  • All the addresses that bought some tokens though DEXES without selling them
  • All the "True" token holders

Holdings distribution without extreme values¶

5348 holders have more than 100 CAPS

Some dapps offer a tiering systems for they users that enables different perks. The following analysis could be split into the analysis of these different tiers to display major differencies between those groups.

Holders Description¶

Comparer avec les gens qui swap le token utiliser les balances etherscan Regarder l'activité de swapping labeliser non swapper address labeliser passif holders plutot que simple holder

There were 786 active accounts last month

Labeling definition can be improved. What other labels should we add ?

We could add a graph showing the distribution of the age of the users

Some accounts are not labeled since they don't apear in our database. Should we add them ?

Some addresses might have transferred their tokens to other addresses or other chains so holders are not 100% exact. Tracking those transfers could be added for a slight improvement. Current analysis is quite representative when empirically verifying results

We could also cludter the related accounts that have done some inner transfers

This analysis could be handled on all the addresses that interacted with the tokens and not only the current holders

From here bots are removed from the analysis¶

Removing 0.21% bot accounts from the analysis

Should We add the distribution only for users ? Or most precisely active users ?

Show recent holders interaction (4 weeks old)¶

Recent asset swapped¶

Notable recent tokens swaped by Capsule Coin holders removing ['WETH', 'USDC', 'USDT', 'DAI', 'WBTC', 'UNI', 'SUSHI', 'MATIC', 'SHIB', 'HEX']
address name symbol swap_count total_dollar_volume
0x12b6893ce26ea6341919fe289212ef77e51688c8 Tamadoge TAMA 729 4186180.974286
0x0cba60ca5ef4d42f92a5070a8fedd13be93e2861 The Protocol THE 200 651534.921574
0x461b71cff4d4334bba09489ace4b5dc1a1813445 Hoard HRD 114 500204.209430
0x0ab87046fbb341d058f17cbc4c1133f25a20a52f Governance OHM gOHM 235 422790.467720
0x1e4ede388cbc9f4b5c79681b7f94d36a11abebc9 X2Y2Token X2Y2 51 395012.481000
0x9506d37f70eb4c3d79c398d326c871abbf10521d Media Licensing Token MLT 207 376916.712260
0xbd31ea8212119f94a611fa969881cba3ea06fa3d LUNA LUNA 253 357064.780625
0x66bcd0c22bb15cd1ba7199c7a383dc89528f4427 BUHUND BUH 82 323563.253300
0x9e32b13ce7f2e80a01932b42553652e053d6ed8e Metis Token Metis 158 316283.427333
0x04b9788559db3869eb48c76acac7af17c0165b00 DO KWON INU DKWON 84 316033.490820
0xd69f306549e9d96f183b1aeca30b8f4353c2ecc3 MCHCoin MCHC 191 303497.905810
0xaf9f549774ecedbd0966c52f250acc548d3f36e5 Rio Fuel Token RFuel 117 298423.625390
0x2559813bbb508c4c79e9ccce4703bcb1f149edd7 HOURGLASS WAIT 79 293802.549977
0x8f8221afbb33998d8584a2b05749ba73c37a938a Request Token REQ 110 259623.678545
0x761d38e5ddf6ccf6cf7c55759d5210750b5d60f3 Dogelon ELON 16 219325.315970
0x120a3879da835a5af037bb2d1456bebd6b54d4ba Revest RVST 34 212110.724400
0x0b452278223d3954f4ac050949d7998e373e7e43 Shita-Kiri Suzume SUZUME 54 211919.169750
0x5b7533812759b45c2b44c19e320ba2cd2681b542 SingularityNET Token AGIX 47 208427.014438
0x9d71ce49ab8a0e6d2a1e7bfb89374c9392fd6804 NvirWorld Nvir 48 181784.281975
0x00a8b738e453ffd858a7edf03bccfe20412f0eb0 AllianceBlock Token ALBT 139 181242.269562

Do we need to analyze recent swaps more in depth ?

Recent contract interaction by removing ERC20 Tokens¶

to_address transaction_count distinct_address_count label
0x68b3465833fb72a70ecdf485e0e4c7bd8665fc45 1001 232 Uniswap V3 Router
0x00000000006c3852cbef3e08e8df289169ede581 505 107 Seaport 1.1
0x881d40237659c251811cec9c364ef91dc08d300c 156 92 Metamask Router
0xeb489e829ff10419a8e808fc8e0003134536ad71 63 44 nan
0x1111111254fb6c44bac0bed2854e76f90643097d 9163 44 1inch v4 Router
0xa0c68c638235ee32657e8f720a23cec1bfc77c77 2905 40 Polygon Matic Bridge
0x65c2e54a4c75ff6da7b6b32369c1677250075fb2 39 39 nan
0x73173f8c1e02c21cde31854c8fe917fce9b94e9e 39 31 TWVPKLand (TWVPK)
0xdef171fe48cf0115b1d80b88dc8eab59176fee57 737 27 Paraswap Augustus v5
0x4dbd4fc535ac27206064b68ffcf827b0a60bab3f 30 26 Arbitrum: Delayed Inbox
0xd9e1ce17f2641f24ae83637ab66a2cca9c378b9f 185 21 SushiSwap Router
0x283af0b28c62c092c9727f1ee09c02ca627eb7f5 229 20 ENS: ETH Registrar Controller
0xe66b31678d6c16e9ebf358268a790b763c133750 169 18 0x: Coinbase Wallet Proxy
0xf2e391f11cd1609679d03a1ac965b1d0432a7007 20 17 nan
0x57f1887a8bf19b14fc0df6fd9b2acc9af147ea85 24 14 ENS: Base Registrar Implementation
0xc4448b71118c9071bcb9734a0eac55d18a153949 16 14 Arbitrum Nova: Delayed Inbox
0x80c67432656d59144ceff962e8faf8926599bcf8 20 14 nan
0xf5c9f957705bea56a7e806943f98f7777b995826 24 13 Sorare: L2 Bridge
0x0000000000c2d145a2526bd8c716263bfebe1a72 19 12 Opensea: Transfer Helper
0xabea9132b05a70803a4e85094fd0e1800777fbef 18 11 zkSync
0xdef1c0ded9bec7f1a1670819833240f027b25eff 421 11 0x: Exchange Proxy
0x0e42acbd23faee03249daff896b78d7e79fbd58e 18 11 veSTG (veSTG)
0x765277eebeca2e31912c9946eae1021199b39c61 431 10 Multichain: Router V4 2
0x5564886ca2c518d1964e5fcea4f423b41db9f561 43 10 Linagee Name Registrar
0x495f947276749ce646f68ac8c248420045cb7b5e 10 10 OpenSea: OPENSTORE Token
0x3ee18b2214aff97000d974cf647e7c347e8fa585 319 10 Wormhole: Portal Token Bridge
0xa6b71e26c5e0845f74c812102ca7114b6a896ab2 9 9 Safe: Proxy Factory 1.3.0

All time User interaction¶

Most swapped assets all time by token holders¶

Notable tokens held by Capsule Coin holders removing ['WETH', 'USDC', 'USDT', 'DAI', 'WBTC', 'UNI', 'SUSHI', 'MATIC', 'SHIB', 'HEX']
unique_account_count name symbol price usd_exposure address
3602 Capsule Coin CAPS 0.009671 2725896.659092 0x03be5c903c727ee2c8c4e9bc0acc860cca4715e2
446 Ultra Token UOS 0.286579 1125281.281384 0xd13c7342e1ef687c5ad21b27c2b65d772cab5c8c
300 UnirisToken UCO 0.068127 575363.211707 0x8a3d77e9d6968b780564936d15b09805827c21fa
261 Polkamon PMON 1.195693 410812.697235 0x1796ae0b0fa4862485106a0de9b654efe301d0b2
240 PolkastarterToken POLS 0.422410 807939.099854 0x83e6f1e41cdd28eaceb20cb649155049fac3d5aa
234 @EthernityChain $ERN Token ERN 2.647040 2321925.065177 0xbbc2ae13b23d715c30720f079fcd9b4a74093505
206 Exeedme XED 0.060732 440639.019622 0xee573a945b01b788b9287ce062a0cfc15be9fd86
203 Poken PKN 0.001375 28844.188004 0xdf09a216fac5adc3e640db418c0b956076509503
191 PAID Network PAID 0.017761 659856.843616 0x1614f18fc94f47967a3fbe5ffcd46d4e7da3d787
162 SuperFarm SUPER 0.117487 1334056.995430 0xe53ec727dbdeb9e2d5456c3be40cff031ab40a55
150 Morpheus.Network MRPH 1.254034 195720.749664 0x7b0c06043468469967dba22d1af33d77d44056c8
147 OVR OVR 0.635270 569598.685082 0x21bfbda47a0b4b5b1248c767ee49f7caa9b23697
143 Rarible RARI 2.028400 202935.020813 0xfca59cd816ab1ead66534d82bc21e7515ce441cf
131 Dogelon ELON 0.000000 7403355.253496 0x761d38e5ddf6ccf6cf7c55759d5210750b5d60f3
131 DAO Maker DAO 1.265900 2024738.611798 0x0f51bb10119727a7e5ea3538074fb341f56b09ad
125 Merchant Token MTO 0.037302 10160.272263 0xe66b3aa360bb78468c00bebe163630269db3324f
123 VERA VRA 0.003877 305319.151064 0xf411903cbc70a74d22900a5de66a2dda66507255
122 Sora Token XOR 4.922820 112846.482677 0x40fd72257597aa14c7231a7b1aaa29fce868f677
121 Polkamarkets POLK 0.060261 85260.882180 0xd478161c952357f05f0292b56012cd8457f1cfbf
110 1INCH Token 1INCH 0.554897 238461.341391 0x111111111117dc0aa78b770fa6a738034120c302
  • This Could be improved by labeling tokens category such as (DeFi, P2E, Stables etc ...)
  • Same table can be done with all accounts that interacted with the token, not only the current holders

Most used contracts by holders by removing ERC20 Tokens¶

to_address transaction_count distinct_address_count label
0x881d40237659c251811cec9c364ef91dc08d300c 7623 1310 Metamask Router
0x68b3465833fb72a70ecdf485e0e4c7bd8665fc45 8847 1214 Uniswap V3 Router
0xe592427a0aece92de3edee1f18e0157c05861564 10129 1185 Uniswap V3 Router
0xa0c68c638235ee32657e8f720a23cec1bfc77c77 14707 652 Polygon Matic Bridge
0x7be8076f4ea4a4ad08075c2508e481d6c946d12b 7506 606 Opensea Wyvern exchange V1
0xa5409ec958c83c3f309868babaca7c86dcb077c1 563 508 Opensea Registry
0xd9e1ce17f2641f24ae83637ab66a2cca9c378b9f 6577 508 SushiSwap Router
0x6a58eb0d64974e7e76e8f1080e53db86e348bceb 454 428 Polychain Monsters: Egg Claims
0x7f268357a8c2552623316e2562d90e642bb538e5 3032 341 Opensea Wyvern exchange v2
0xeb489e829ff10419a8e808fc8e0003134536ad71 791 312 nan
0x00000000006c3852cbef3e08e8df289169ede581 2762 301 Seaport 1.1
0x4dbd4fc535ac27206064b68ffcf827b0a60bab3f 432 298 Arbitrum: Delayed Inbox
0x11111112542d85b3ef69ae05771c2dccff4faa26 12738 247 1inch v3
0xdef171fe48cf0115b1d80b88dc8eab59176fee57 10489 237 Paraswap Augustus v5
0x283af0b28c62c092c9727f1ee09c02ca627eb7f5 1986 231 ENS: ETH Registrar Controller
0xdef1c0ded9bec7f1a1670819833240f027b25eff 2507 225 0x: Exchange Proxy
0x401f6c983ea34274ec46f84d70b31c151321188b 285 200 Polygon (Matic): Plasma Bridge
0x99c9fc46f92e8a1c0dec1b1747d010903e884be1 311 187 Optimism Gateway
0x1111111254fb6c44bac0bed2854e76f90643097d 114706 180 1inch v4 Router
0xabea9132b05a70803a4e85094fd0e1800777fbef 251 151 zkSync
0x084b1c3c81545d370f3634392de611caabff8148 191 148 ENS Reverse Register
0x090d4613473dee047c3f2706764f49e0821d256e 162 147 Uniswap token Distributor
0x1bd435f3c054b6e901b7b108a0ab7617c808677b 461 139 ParaSwap P4
0xba12222222228d8ba445958a75a0704d566bf2c8 370 133 Balancer Vault

Open questions and ideas¶

New Holders/Users analysis and notifications

Should we show holdings evolution through time ? Or interactions through time ? Daily contract Usage

Stickyness and churn analysis ? Analyse how many addresses keep using the contract or churned ?

Add a User leader board ?

Should we perform the same analysis on only active addresses ? Or historical users ?

Should we try deducting timezones based on activity timestamp ?

For general contracts should we add a google analytics Integration ?

What other labels can we add ?

Should we tag tokens and contracts in different categories such as DEFI, P2E ... ?

What other data do you want to measure on your users/holders ?

Are True User balance in ERC20 and ERC721 Usefull ?

Should We add a community tool ? Could be used to find Addresses that belong to the same owner or that have same onchain behaviour ?

Registered ENS analysis, Scrap data about all addresses that have a registered ENS.